package com.hongdee.crm.tdc.mapper;

import com.hongdee.crm.tdc.pojo.CallRecordVo;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @author zhangkai
 * @desc 一句话描述
 **/
@Mapper
public interface CallRecordMapper {

    /****
     * 查询回访记录
     */
    @SelectProvider(type = CallRecordSQL.class, method = "callRecordSQL")
    @Results({

            @Result(column = "sa", property = "sa"),
            @Result(column = "vin", property = "vin"),
            @Result(column = "plateNum", property = "plateNum"),
            @Result(column = "owner_name", property = "ownerName"),
            @Result(column = "owner_tel", property = "ownerTel"),
            @Result(column = "order_num", property = "orderNum"),
            @Result(column = "deal_date", property = "dealDate"),
            @Result(column = "callCount", property = "callCount"),

            @Result(column = "narie_code", property = "narieCode"),
            @Result(column = "score", property = "score"),
            @Result(column = "degree", property = "degree"),
            @Result(column = "type", property = "type"),
            @Result(column = "content", property = "content"),
    })
    List<CallRecordVo> findCallRecord(
            @Param("companyId") String companyId, @Param("vin") String vin
            , @Param("plateNum") String plateNum, @Param("SA") String sa,
            @Param("orderNum") String orderNum) throws Exception;

}
